Tabela PhStockOrderApprovalNo

Definicja tabeli PhStockOrderApprovalNo

Name

PhStockOrderApprovalNo

Code

PhStockOrderApprovalNo

Comment

Numery i daty akceptacji zamówien


Lista kolumn tabeli PhStockOrderApprovalNo

Name

Code

StockOrderApprovalID

StockOrderApprovalID

StOrderID

StOrderID

DirectorateApprovalNo

DirectorateApprovalNo

DirectorateAcceptationDT

DirectorateAcceptationDT

HeadOfTheWardApprovalNo

HeadOfTheWardApprovalNo

HeadOfTheWardAcceptationDT

HeadOfTheWardAcceptationDT

PharmacyApprovalNo

PharmacyApprovalNo

PharmacyAcceptationDt

PharmacyAcceptationDt


Kolumna StockOrderApprovalID tabeli PhStockOrderApprovalNo

Definicja kolumny StockOrderApprovalID tabeli PhStockOrderApprovalNo

Name

StockOrderApprovalID

Code

StockOrderApprovalID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StOrderID tabeli PhStockOrderApprovalNo

Definicja kolumny StOrderID tabeli PhStockOrderApprovalNo

Name

StOrderID

Code

StOrderID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DirectorateApprovalNo tabeli PhStockOrderApprovalNo

Definicja kolumny DirectorateApprovalNo tabeli PhStockOrderApprovalNo

Name

DirectorateApprovalNo

Code

DirectorateApprovalNo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

zgoda dyrekcji


Kolumna DirectorateAcceptationDT tabeli PhStockOrderApprovalNo

Definicja kolumny DirectorateAcceptationDT tabeli PhStockOrderApprovalNo

Name

DirectorateAcceptationDT

Code

DirectorateAcceptationDT

Data Type

DATE

Mandatory

No

Comment

Data zgody dyrekcji


Kolumna HeadOfTheWardApprovalNo tabeli PhStockOrderApprovalNo

Definicja kolumny HeadOfTheWardApprovalNo tabeli PhStockOrderApprovalNo

Name

HeadOfTheWardApprovalNo

Code

HeadOfTheWardApprovalNo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

zgoda ordynatora


Kolumna HeadOfTheWardAcceptationDT tabeli PhStockOrderApprovalNo

Definicja kolumny HeadOfTheWardAcceptationDT tabeli PhStockOrderApprovalNo

Name

HeadOfTheWardAcceptationDT

Code

HeadOfTheWardAcceptationDT

Data Type

DATE

Mandatory

No

Comment

data zgody ordynatora


Kolumna PharmacyApprovalNo tabeli PhStockOrderApprovalNo

Definicja kolumny PharmacyApprovalNo tabeli PhStockOrderApprovalNo

Name

PharmacyApprovalNo

Code

PharmacyApprovalNo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Kolumny beda przechowywaly numer oraz date zgody apteki centralnej.


Kolumna PharmacyAcceptationDt tabeli PhStockOrderApprovalNo

Definicja kolumny PharmacyAcceptationDt tabeli PhStockOrderApprovalNo

Name

PharmacyAcceptationDt

Code

PharmacyAcceptationDt

Data Type

DATE

Mandatory

No

Comment

Kolumny beda przechowywaly numer oraz date zgody apteki centralnej.


Lista kluczy tabeli PhStockOrderApprovalNo

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PhStockOrderApprovalNo

Definicja klucza Identifier_1 tabeli PhStockOrderApprovalNo

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment